package main

import "fmt"

func GetProjectInfoByProjectItemGUID1(ContractNumber, SupervisionOrganization, TestOrganization, ConstructionOrganization, OwnerOrganization, DesignOrganization string) {
	s := fmt.Sprintf(`
		%s ContractNumber,
		%s SupervisionOrganization,
		%s TestOrganization,
		%s ConstructionOrganization,
		%s OwnerOrganization,
		%s DesignOrganization,
		base_project.GUID AS ProjectGUID,
		base_project.Name AS ProjectName,
		tender.GUID AS TenderGUID,
        tender.Name AS TenderName,
        tender.Number AS TenderNumber,
        subproject.GUID AS SubprojectGUID,
        subproject.Name AS SubprojectName,
        subproject.Number AS SubprojectNumber,
        base_subsection_project.GUID AS SubsectionprojectGUID,
        base_subsection_project.Name AS SubsectionprojectName,
        base_subentry_project.GUID AS SubentryprojectGUID,
        base_subentry_project.Name AS SubentryprojectName,
        base_subentry_project.Number AS SubentryprojectNumber,
        base_project_item.GUID AS ProjectitemGUID,
        base_project_item.Name AS ProjectitemName,
        base_project_item.Number AS ProjectitemNumber
	`, ContractNumber, SupervisionOrganization, TestOrganization, ConstructionOrganization, OwnerOrganization, DesignOrganization)

	fmt.Println(s)
}

func main() {
	/* var userGUID int64 = 32
	a := fmt.Sprintf("chk_table_record.Status='Submited' And (chk_table_signatureitem_record.UserGUID != %d ", userGUID)
	fmt.Println(a) */
	GetProjectInfoByProjectItemGUID1("x1", "x2", "x3", "x4", "x5", "x6")
}
